Pandas Profiling Report

Dataset statistics

Number of variables	15
Number of observations	456240
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	30.9 MiB
Average record size in memory	71.0 B

Variable types

Numeric	10
Boolean	2
Categorical	3

Warnings

`preco_checkout` is highly correlated with `preco_base`	High correlation
`preco_base` is highly correlated with `preco_checkout`	High correlation
`preco_checkout` is highly correlated with `preco_base`	High correlation
`preco_base` is highly correlated with `preco_checkout`	High correlation
`preco_checkout` is highly correlated with `preco_base`	High correlation
`preco_base` is highly correlated with `preco_checkout`	High correlation
`df_index` is highly correlated with `cidade_codigo` and 3 other fields	High correlation
`pagina_destaque` is highly correlated with `email_para_promocao`	High correlation
`cidade_codigo` is highly correlated with `df_index` and 4 other fields	High correlation
`preco_checkout` is highly correlated with `preco_base` and 3 other fields	High correlation
`preco_base` is highly correlated with `preco_checkout` and 3 other fields	High correlation
`qtd_pedido` is highly correlated with `categoria`	High correlation
`cozinha` is highly correlated with `preco_checkout` and 3 other fields	High correlation
`refeicao_id` is highly correlated with `preco_checkout` and 3 other fields	High correlation
`regiao_codigo` is highly correlated with `df_index` and 2 other fields	High correlation
`loja_tipo` is highly correlated with `cidade_codigo` and 1 other fields	High correlation
`loja_id` is highly correlated with `df_index` and 3 other fields	High correlation
`email_para_promocao` is highly correlated with `pagina_destaque`	High correlation
`op_area` is highly correlated with `df_index` and 3 other fields	High correlation
`categoria` is highly correlated with `preco_checkout` and 4 other fields	High correlation
`cozinha` is highly correlated with `categoria`	High correlation
`categoria` is highly correlated with `cozinha`	High correlation
`df_index` is uniformly distributed	Uniform
`df_index` has unique values	Unique

Reproduction

Analysis started	2021-08-29 18:36:51.815858
Analysis finished	2021-08-29 18:37:36.757318
Duration	44.94 seconds
Software version	pandas-profiling v3.0.0
Download configuration	config.json

df_index
Real number (ℝ_≥0)

HIGH CORRELATION
UNIFORM
UNIQUE

Distinct	456240
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	228264.5684

Minimum	0
Maximum	456547
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	3.5 MiB

Quantile statistics

Minimum	0
5-th percentile	22825.95
Q1	114138.75
median	228260.5
Q3	342376.25
95-th percentile	433719.05
Maximum	456547
Range	456547
Interquartile range (IQR)	228237.5

Descriptive statistics

Standard deviation	131785.5114
Coefficient of variation (CV)	0.5773366944
Kurtosis	-1.199740008
Mean	228264.5684
Median Absolute Deviation (MAD)	114119
Skewness	0.0001090528568
Sum	1.041434267 × 10¹¹
Variance	1.7367421 × 10¹⁰
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	< 0.1%
248620	1	< 0.1%
201527	1	< 0.1%
203574	1	< 0.1%
197429	1	< 0.1%
199476	1	< 0.1%
209715	1	< 0.1%
211762	1	< 0.1%
205617	1	< 0.1%
207664	1	< 0.1%
Other values (456230)	456230	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
456547	1	< 0.1%
456546	1	< 0.1%
456545	1	< 0.1%
456544	1	< 0.1%
456543	1	< 0.1%
456542	1	< 0.1%
456541	1	< 0.1%
456540	1	< 0.1%
456539	1	< 0.1%
456538	1	< 0.1%

semana
Real number (ℝ_≥0)

Distinct	145
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	74.78105602

Minimum	1
Maximum	145
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.5 MiB

Quantile statistics

Minimum	1
5-th percentile	9
Q1	39
median	76
Q3	111
95-th percentile	139
Maximum	145
Range	144
Interquartile range (IQR)	72

Descriptive statistics

Standard deviation	41.51946501
Coefficient of variation (CV)	0.555213676
Kurtosis	-1.179373225
Mean	74.78105602
Median Absolute Deviation (MAD)	36
Skewness	-0.04959792359
Sum	34118109
Variance	1723.865975
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
122	3355	0.7%
105	3348	0.7%
106	3347	0.7%
140	3332	0.7%
123	3328	0.7%
134	3322	0.7%
133	3319	0.7%
113	3312	0.7%
143	3305	0.7%
94	3303	0.7%
Other values (135)	422969	92.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	2922	0.6%
2	2896	0.6%
3	2899	0.6%
4	2889	0.6%
5	2810	0.6%
6	2823	0.6%
7	2769	0.6%
8	2785	0.6%
9	2854	0.6%
10	2859	0.6%

Value	Count	Frequency (%)
145	3268	0.7%
144	3302	0.7%
143	3305	0.7%
142	3238	0.7%
141	3263	0.7%
140	3332	0.7%
139	3279	0.7%
138	3278	0.7%
137	3283	0.7%
136	3273	0.7%

loja_id
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	77
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	82.10862485

Minimum	10
Maximum	186
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.5 MiB

Quantile statistics

Minimum	10
5-th percentile	14
Q1	43
median	76
Q3	110
95-th percentile	161
Maximum	186
Range	176
Interquartile range (IQR)	67

Descriptive statistics

Standard deviation	45.97466228
Coefficient of variation (CV)	0.5599248844
Kurtosis	-0.805091574
Mean	82.10862485
Median Absolute Deviation (MAD)	33
Skewness	0.3452015749
Sum	37461239
Variance	2113.669572
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13	7026	1.5%
10	7006	1.5%
52	6983	1.5%
43	6922	1.5%
67	6904	1.5%
174	6883	1.5%
51	6873	1.5%
137	6873	1.5%
27	6849	1.5%
108	6838	1.5%
Other values (67)	387083	84.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
10	7006	1.5%
11	6790	1.5%
13	7026	1.5%
14	6040	1.3%
17	6333	1.4%
20	6671	1.5%
23	6433	1.4%
24	5232	1.1%
26	5084	1.1%
27	6849	1.5%

Value	Count	Frequency (%)
186	5528	1.2%
177	5296	1.2%
174	6883	1.5%
162	4366	1.0%
161	5591	1.2%
157	5709	1.3%
153	6693	1.5%
152	5917	1.3%
149	5021	1.1%
146	6161	1.4%

refeicao_id
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	51
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2024.306922

Minimum	1062
Maximum	2956
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.5 MiB

Quantile statistics

Minimum	1062
5-th percentile	1198
Q1	1558
median	1993
Q3	2539
95-th percentile	2760
Maximum	2956
Range	1894
Interquartile range (IQR)	981

Descriptive statistics

Standard deviation	547.5381884
Coefficient of variation (CV)	0.2704818042
Kurtosis	-1.243793678
Mean	2024.306922
Median Absolute Deviation (MAD)	499
Skewness	-0.1726072093
Sum	923569790
Variance	299798.0677
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1062	11137	2.4%
2707	11123	2.4%
1778	11121	2.4%
1109	11119	2.4%
1727	11119	2.4%
1993	11115	2.4%
1962	11114	2.4%
1754	11087	2.4%
1885	11080	2.4%
2581	11072	2.4%
Other values (41)	345153	75.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1062	11137	2.4%
1109	11119	2.4%
1198	4206	0.9%
1207	10806	2.4%
1216	9695	2.1%
1230	10745	2.4%
1247	7184	1.6%
1248	9939	2.2%
1311	4682	1.0%
1438	4385	1.0%

Value	Count	Frequency (%)
2956	3319	0.7%
2867	8092	1.8%
2826	11056	2.4%
2760	10209	2.2%
2707	11123	2.4%
2704	9811	2.2%
2664	9853	2.2%
2640	10747	2.4%
2631	10458	2.3%
2581	11072	2.4%

preco_checkout
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1990
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	332.3371971

Minimum	45.62
Maximum	767.33
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.5 MiB

Quantile statistics

Minimum	45.62
5-th percentile	121.28
Q1	228.98
median	296.82
Q3	445.23
95-th percentile	640.23
Maximum	767.33
Range	721.71
Interquartile range (IQR)	216.25

Descriptive statistics

Standard deviation	152.9378086
Coefficient of variation (CV)	0.4601886575
Kurtosis	-0.2537255609
Mean	332.3371971
Median Absolute Deviation (MAD)	104.73
Skewness	0.6715232236
Sum	151625522.8
Variance	23389.97329
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
290.03	7340	1.6%
291.03	7275	1.6%
292.03	7199	1.6%
486.03	6635	1.5%
484.03	6631	1.5%
485.03	6584	1.4%
280.33	5833	1.3%
281.33	5828	1.3%
282.33	5729	1.3%
447.23	5240	1.1%
Other values (1980)	391946	85.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
45.62	1	< 0.1%
47.59	1	< 0.1%
53.41	1	< 0.1%
55.35	3	< 0.1%
56.26	1	< 0.1%
58.26	1	< 0.1%
64.02	3	< 0.1%
65.02	5	< 0.1%
65.96	1	< 0.1%
66.02	6	< 0.1%

Value	Count	Frequency (%)
767.33	217	< 0.1%
766.33	222	< 0.1%
765.33	184	< 0.1%
760.54	2	< 0.1%
759.57	1	< 0.1%
759.54	1	< 0.1%
758.54	1	< 0.1%
757.63	2	< 0.1%
756.63	2	< 0.1%
755.66	1	< 0.1%

preco_base
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1907
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	354.192825

Minimum	55.35
Maximum	866.27
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.5 MiB

Quantile statistics

Minimum	55.35
5-th percentile	144.53
Q1	243.5
median	310.46
Q3	459.81
95-th percentile	668.33
Maximum	866.27
Range	810.92
Interquartile range (IQR)	216.31

Descriptive statistics

Standard deviation	160.7554415
Coefficient of variation (CV)	0.4538641954
Kurtosis	-0.5079199783
Mean	354.192825
Median Absolute Deviation (MAD)	111.49
Skewness	0.6370089178
Sum	161596934.5
Variance	25842.31198
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
292.03	9509	2.1%
290.03	9381	2.1%
291.03	9377	2.1%
280.33	6837	1.5%
282.33	6561	1.4%
281.33	6476	1.4%
445.23	6304	1.4%
446.23	6262	1.4%
447.23	6229	1.4%
486.03	5607	1.2%
Other values (1897)	383697	84.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
55.35	1	< 0.1%
64.02	1	< 0.1%
65.02	1	< 0.1%
66.02	1	< 0.1%
72.75	1	< 0.1%
73.75	1	< 0.1%
74.75	1	< 0.1%
75.66	1	< 0.1%
79.54	1	< 0.1%
81.54	2	< 0.1%

Value	Count	Frequency (%)
866.27	2	< 0.1%
865.27	4	< 0.1%
864.27	1	< 0.1%
767.33	284	0.1%
766.33	282	0.1%
765.33	292	0.1%
760.54	1	< 0.1%
759.57	1	< 0.1%
759.54	1	< 0.1%
758.54	2	< 0.1%

email_para_promocao
Boolean

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	445.7 KiB

False	419456
True	36784

Common Values
Chart

Value	Count	Frequency (%)
False	419456	91.9%
True	36784	8.1%

pagina_destaque
Boolean

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	445.7 KiB

False	406617
True	49623

Common Values
Chart

Value	Count	Frequency (%)
False	406617	89.1%
True	49623	10.9%

qtd_pedido
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	994
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.870489116

Minimum	2.564949357
Maximum	8.466110401
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.5 MiB

Quantile statistics

Minimum	2.564949357
5-th percentile	2.63905733
Q1	3.988984047
median	4.912654886
Q3	5.780743516
95-th percentile	6.776506992
Maximum	8.466110401
Range	5.901161044
Interquartile range (IQR)	1.791759469

Descriptive statistics

Standard deviation	1.215326969
Coefficient of variation (CV)	0.2495287311
Kurtosis	-0.6372417251
Mean	4.870489116
Median Absolute Deviation (MAD)	0.9103910097
Skewness	-0.06512203977
Sum	2222111.954
Variance	1.477019641
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2.564949357	12397	2.7%
2.708050201	12294	2.7%
2.63905733	12269	2.7%
3.33220451	11548	2.5%
3.295836866	11462	2.5%
3.258096538	11457	2.5%
3.713572067	10344	2.3%
3.688879454	10179	2.2%
3.737669618	10083	2.2%
3.988984047	8845	1.9%
Other values (984)	345362	75.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2.564949357	12397	2.7%
2.63905733	12269	2.7%
2.708050201	12294	2.7%
3.258096538	11457	2.5%
3.295836866	11462	2.5%
3.33220451	11548	2.5%
3.688879454	10179	2.2%
3.713572067	10344	2.3%
3.737669618	10083	2.2%
3.970291914	8715	1.9%

Value	Count	Frequency (%)
8.466110401	1	< 0.1%
8.463581422	2	< 0.1%
8.460834458	3	< 0.1%
8.46062284	1	< 0.1%
8.457867725	2	< 0.1%
8.457655479	2	< 0.1%
8.455104999	3	< 0.1%
8.454679286	1	< 0.1%
8.452121195	1	< 0.1%
8.451907725	1	< 0.1%

categoria
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	14
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	446.3 KiB

Beverages	127876
Rice Bowl	33215
Sandwich	33205
Pizza	33138
Starters	29941
Other values (9)	198865

Length

Max length	12
Median length	8
Mean length	7.530481764
Min length	4

Characters and Unicode

Total characters	3435707
Distinct characters	31
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Beverages
2nd row	Beverages
3rd row	Beverages
4th row	Beverages
5th row	Beverages

Common Values

Value	Count	Frequency (%)
Beverages	127876	28.0%
Rice Bowl	33215	7.3%
Sandwich	33205	7.3%
Pizza	33138	7.3%
Starters	29941	6.6%
Other Snacks	29379	6.4%
Desert	29294	6.4%
Salad	28545	6.3%
Pasta	27694	6.1%
Seafood	26915	5.9%
Other values (4)	57038	12.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
beverages	127876	24.6%
bowl	33215	6.4%
rice	33215	6.4%
sandwich	33205	6.4%
pizza	33138	6.4%
starters	29941	5.8%
other	29379	5.7%
snacks	29379	5.7%
desert	29294	5.6%
salad	28545	5.5%
Other values (6)	111647	21.5%

Most occurring characters

Value	Count	Frequency (%)
e	561666	16.3%
a	427108	12.4%
r	280607	8.2%
s	267933	7.8%
B	181705	5.3%
S	160660	4.7%
t	159811	4.7%
i	150973	4.4%
v	127876	3.7%
g	127876	3.7%
Other values (21)	989492	28.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2854279	83.1%
Uppercase Letter	518834	15.1%
Space Separator	62594	1.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	561666	19.7%
a	427108	15.0%
r	280607	9.8%
s	267933	9.4%
t	159811	5.6%
i	150973	5.3%
v	127876	4.5%
g	127876	4.5%
o	99720	3.5%
c	95799	3.4%
Other values (12)	554910	19.4%

Uppercase Letter

Value	Count	Frequency (%)
B	181705	35.0%
S	160660	31.0%
P	60832	11.7%
R	33215	6.4%
O	29379	5.7%
D	29294	5.6%
E	13562	2.6%
F	10187	2.0%

Space Separator

Value	Count	Frequency (%)
	62594	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3373113	98.2%
Common	62594	1.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	561666	16.7%
a	427108	12.7%
r	280607	8.3%
s	267933	7.9%
B	181705	5.4%
S	160660	4.8%
t	159811	4.7%
i	150973	4.5%
v	127876	3.8%
g	127876	3.8%
Other values (20)	926898	27.5%

Common

Value	Count	Frequency (%)
	62594	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3435707	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	561666	16.3%
a	427108	12.4%
r	280607	8.2%
s	267933	7.8%
B	181705	5.3%
S	160660	4.7%
t	159811	4.7%
i	150973	4.4%
v	127876	3.7%
g	127876	3.7%
Other values (21)	989492	28.8%

cozinha
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	445.9 KiB

Italian	122825
Thai	118203
Indian	112419
Continental	102793

Length

Max length	11
Median length	6
Mean length	6.877573207
Min length	4

Characters and Unicode

Total characters	3137824
Distinct characters	12
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Thai
2nd row	Thai
3rd row	Thai
4th row	Thai
5th row	Thai

Common Values

Value	Count	Frequency (%)
Italian	122825	26.9%
Thai	118203	25.9%
Indian	112419	24.6%
Continental	102793	22.5%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
italian	122825	26.9%
thai	118203	25.9%
indian	112419	24.6%
continental	102793	22.5%

Most occurring characters

Value	Count	Frequency (%)
n	656042	20.9%
a	579065	18.5%
i	456240	14.5%
t	328411	10.5%
I	235244	7.5%
l	225618	7.2%
T	118203	3.8%
h	118203	3.8%
d	112419	3.6%
C	102793	3.3%
Other values (2)	205586	6.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2681584	85.5%
Uppercase Letter	456240	14.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
n	656042	24.5%
a	579065	21.6%
i	456240	17.0%
t	328411	12.2%
l	225618	8.4%
h	118203	4.4%
d	112419	4.2%
o	102793	3.8%
e	102793	3.8%

Uppercase Letter

Value	Count	Frequency (%)
I	235244	51.6%
T	118203	25.9%
C	102793	22.5%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3137824	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
n	656042	20.9%
a	579065	18.5%
i	456240	14.5%
t	328411	10.5%
I	235244	7.5%
l	225618	7.2%
T	118203	3.8%
h	118203	3.8%
d	112419	3.6%
C	102793	3.3%
Other values (2)	205586	6.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3137824	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
n	656042	20.9%
a	579065	18.5%
i	456240	14.5%
t	328411	10.5%
I	235244	7.5%
l	225618	7.2%
T	118203	3.8%
h	118203	3.8%
d	112419	3.6%
C	102793	3.3%
Other values (2)	205586	6.6%

cidade_codigo
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	51
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	601.5494455

Minimum	456
Maximum	713
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.5 MiB

Quantile statistics

Minimum	456
5-th percentile	478
Q1	553
median	596
Q3	651
95-th percentile	700
Maximum	713
Range	257
Interquartile range (IQR)	98

Descriptive statistics

Standard deviation	66.20361943
Coefficient of variation (CV)	0.1100551583
Kurtosis	-0.7912046047
Mean	601.5494455
Median Absolute Deviation (MAD)	53
Skewness	-0.2090812318
Sum	274450919
Variance	4382.919226
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
590	54635	12.0%
526	43508	9.5%
638	20028	4.4%
522	13456	2.9%
517	13105	2.9%
604	13052	2.9%
699	12089	2.6%
647	11818	2.6%
576	11451	2.5%
614	11330	2.5%
Other values (41)	251768	55.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
456	6713	1.5%
461	5762	1.3%
473	5853	1.3%
478	5021	1.1%
485	5707	1.3%
515	5084	1.1%
517	13105	2.9%
522	13456	2.9%
526	43508	9.5%
541	4501	1.0%

Value	Count	Frequency (%)
713	6849	1.5%
703	6703	1.5%
702	5264	1.2%
700	6883	1.5%
699	12089	2.6%
698	6433	1.4%
695	5294	1.2%
693	4627	1.0%
685	6983	1.5%
683	5296	1.2%

regiao_codigo
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	56.61246274

Minimum	23
Maximum	93
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.5 MiB

Quantile statistics

Minimum	23
5-th percentile	34
Q1	34
median	56
Q3	77
95-th percentile	85
Maximum	93
Range	70
Interquartile range (IQR)	43

Descriptive statistics

Standard deviation	17.64357046
Coefficient of variation (CV)	0.3116552365
Kurtosis	-1.05161428
Mean	56.61246274
Median Absolute Deviation (MAD)	21
Skewness	0.05627398237
Sum	25828870
Variance	311.2955787
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
56	191022	41.9%
34	116686	25.6%
77	94580	20.7%
85	30268	6.6%
23	6433	1.4%
71	6278	1.4%
93	5709	1.3%
35	5264	1.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
23	6433	1.4%
34	116686	25.6%
35	5264	1.2%
56	191022	41.9%
71	6278	1.4%
77	94580	20.7%
85	30268	6.6%
93	5709	1.3%

Value	Count	Frequency (%)
93	5709	1.3%
85	30268	6.6%
77	94580	20.7%
71	6278	1.4%
56	191022	41.9%
35	5264	1.2%
34	116686	25.6%
23	6433	1.4%

loja_tipo
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	445.8 KiB

TYPE_A	262689
TYPE_C	99544
TYPE_B	94007

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Characters and Unicode

Total characters	2737440
Distinct characters	8
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	TYPE_C
2nd row	TYPE_C
3rd row	TYPE_C
4th row	TYPE_C
5th row	TYPE_C

Common Values

Value	Count	Frequency (%)
TYPE_A	262689	57.6%
TYPE_C	99544	21.8%
TYPE_B	94007	20.6%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
type_a	262689	57.6%
type_c	99544	21.8%
type_b	94007	20.6%

Most occurring characters

Value	Count	Frequency (%)
T	456240	16.7%
Y	456240	16.7%
P	456240	16.7%
E	456240	16.7%
_	456240	16.7%
A	262689	9.6%
C	99544	3.6%
B	94007	3.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	2281200	83.3%
Connector Punctuation	456240	16.7%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
T	456240	20.0%
Y	456240	20.0%
P	456240	20.0%
E	456240	20.0%
A	262689	11.5%
C	99544	4.4%
B	94007	4.1%

Connector Punctuation

Value	Count	Frequency (%)
_	456240	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2281200	83.3%
Common	456240	16.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
T	456240	20.0%
Y	456240	20.0%
P	456240	20.0%
E	456240	20.0%
A	262689	11.5%
C	99544	4.4%
B	94007	4.1%

Common

Value	Count	Frequency (%)
_	456240	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2737440	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
T	456240	16.7%
Y	456240	16.7%
P	456240	16.7%
E	456240	16.7%
_	456240	16.7%
A	262689	9.6%
C	99544	3.6%
B	94007	3.4%

op_area
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	30
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.083081711

Minimum	0.9
Maximum	7
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.5 MiB

Quantile statistics

Minimum	0.9
5-th percentile	2.7
Q1	3.6
median	4
Q3	4.5
95-th percentile	6.7
Maximum	7
Range	6.1
Interquartile range (IQR)	0.9

Descriptive statistics

Standard deviation	1.091530289
Coefficient of variation (CV)	0.2673300134
Kurtosis	1.452919071
Mean	4.083081711
Median Absolute Deviation (MAD)	0.5
Skewness	0.6645434202
Sum	1862865.2
Variance	1.191438371
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=30)

Value	Count	Frequency (%)
4	52514	11.5%
3.9	48523	10.6%
3.8	40066	8.8%
4.4	26030	5.7%
4.5	25652	5.6%
2.8	25500	5.6%
4.1	23330	5.1%
7	20660	4.5%
4.8	18642	4.1%
3.4	17257	3.8%
Other values (20)	158066	34.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.9	3432	0.8%
1.9	4083	0.9%
2	9512	2.1%
2.4	5021	1.1%
2.7	12427	2.7%
2.8	25500	5.6%
2.9	4711	1.0%
3	11182	2.5%
3.2	6333	1.4%
3.4	17257	3.8%

Value	Count	Frequency (%)
7	20660	4.5%
6.7	7026	1.5%
6.3	7006	1.5%
5.6	6983	1.5%
5.3	6051	1.3%
5.1	13310	2.9%
5	6161	1.4%
4.8	18642	4.1%
4.7	5975	1.3%
4.6	5975	1.3%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	df_index	semana	loja_id	refeicao_id	preco_checkout	preco_base	email_para_promocao	pagina_destaque	qtd_pedido	categoria	cozinha	cidade_codigo	regiao_codigo	loja_tipo	op_area
0	0	1	55	1885	136.83	152.29	False	False	5.176150	Beverages	Thai	647	56	TYPE_C	2.0
1	1	2	55	1885	135.83	152.29	False	False	5.777652	Beverages	Thai	647	56	TYPE_C	2.0
2	2	3	55	1885	132.92	133.92	False	False	4.564348	Beverages	Thai	647	56	TYPE_C	2.0
3	3	4	55	1885	135.86	134.86	False	False	5.093750	Beverages	Thai	647	56	TYPE_C	2.0
4	4	5	55	1885	146.50	147.50	False	False	5.370638	Beverages	Thai	647	56	TYPE_C	2.0
5	5	6	55	1885	146.53	146.53	False	False	5.652489	Beverages	Thai	647	56	TYPE_C	2.0
6	6	7	55	1885	145.53	146.53	False	False	4.997212	Beverages	Thai	647	56	TYPE_C	2.0
7	7	8	55	1885	146.53	145.53	False	False	4.905275	Beverages	Thai	647	56	TYPE_C	2.0
8	8	9	55	1885	134.83	134.83	False	False	5.164786	Beverages	Thai	647	56	TYPE_C	2.0
9	9	10	55	1885	144.56	143.56	False	False	5.164786	Beverages	Thai	647	56	TYPE_C	2.0

Last rows

	df_index	semana	loja_id	refeicao_id	preco_checkout	preco_base	email_para_promocao	pagina_destaque	qtd_pedido	categoria	cozinha	cidade_codigo	regiao_codigo	loja_tipo	op_area
456230	456538	136	61	2104	571.33	573.33	False	False	2.708050	Fish	Continental	473	77	TYPE_A	4.5
456231	456539	137	61	2104	631.53	631.53	False	False	3.713572	Fish	Continental	473	77	TYPE_A	4.5
456232	456540	138	61	2104	631.53	630.53	False	True	5.010635	Fish	Continental	473	77	TYPE_A	4.5
456233	456541	139	61	2104	490.82	629.53	False	True	5.743003	Fish	Continental	473	77	TYPE_A	4.5
456234	456542	140	61	2104	485.03	629.53	False	True	5.003946	Fish	Continental	473	77	TYPE_A	4.5
456235	456543	141	61	2104	583.03	630.53	False	True	2.564949	Fish	Continental	473	77	TYPE_A	4.5
456236	456544	142	61	2104	581.03	582.03	False	False	3.737670	Fish	Continental	473	77	TYPE_A	4.5
456237	456545	143	61	2104	583.03	581.03	False	False	3.688879	Fish	Continental	473	77	TYPE_A	4.5
456238	456546	144	61	2104	582.03	581.03	False	False	3.970292	Fish	Continental	473	77	TYPE_A	4.5
456239	456547	145	61	2104	581.03	582.03	False	False	3.295837	Fish	Continental	473	77	TYPE_A	4.5

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Connector Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows